2015-09-14 - 22063 - Spec - SNC PO Feed Change #MMPPSupport #sncsup
SPECIFICATIONS
22063-Spec-SNC PO feed change
Purpose
SNC PO Feed Change.
Admin Info
Purpose
|
SNC PO Feed Change
|
Requested By
|
Baiwa Zhang
|
Spec Created By
|
Adithya, Karthikeyan
|
Spec Created Date
|
10/05/2015
|
Spec QA by
|
Adithya
|
Objects
|
ZSNC_PO_EXTRACT
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
12
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
|
|
TOTAL
|
24
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Maintain Header Text same as the new generated file
|
Baiwa
|
10/28/2015
|
|
2
|
Add shipping Ins so as there is no mismatch of the header text
|
Baiwa
|
10/28/2015
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
Currently if any line in the PO is deleted or Shipping Instruction is changed, the PO feed will generate a file for that PO line with no values in it and with deletion indicator.
Requested change is to populate all the Po line details:
1. When Shipping Ins is changed:
All the PO line details shall be populated in the file with "Deletion Indicator - X" in the file for the older Shipping Instruction.
The New file shall be generated with all the PO line details for the New Shipping Instructions.
2. When the PO line is deleted:
All the PO line details shall be populated in the file with "Deletion Indicator - X" in the file for the Shipping Instruction.
This change is requested because the freight forwarders cannot process the file name by opening the file, the lines with deletion indicator only has PO line and PO number, no shipping instruction
so they don't know what to delete and what to reload. The lines for deletion indicator and the new lines cancel each other out
Another change is to add "Street 4" field from Delivery Address to PO feed last column.
Street 4 is from sales order sold-to party. If there is no sales order involved, leave blank
Examples:
1. Scenario:
PO1 - 10 - Extracted the file - 10
PO1 - 10 to 11 - Ran the job - then we would get 2 files 10 (x) and other for 11 (for new Shipping Ins)
(X - File is not having the shipping ins column in the file)
2. PO2 - 15 - Extracted the file - 15
changed the shipping Ins in PO 2 from 15 to 20
created a new PO (PO 3) for shipping instruction 15:
15 SI one line with (X) for PO2 and other line with new PO3 here are not seeing any issue.
- We will have the header text as shown in row 7 for deleted/changed/new files so that the header text in all files are consistent.
- Add shipping Ins for the first scenario changed/deleted files so that there is no mismatch of the headers of the columns.
In Scope:
[List the
activities to be included in scope]
Only the Scenarios which are mentioned above are included.
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Change the program to pull all the details of the PO when the Shipping Instructions in the PO is changed and line item is deleted.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
POFEED001
|
Shipping Instructions change in Purchase Order
|
The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file.
The PO line which is changed should be included in two files,the Old shipping instructions file should have a deleted indicator with all the details of that PO line.
|
POFEED002
|
Deleted the PO line
|
The entire PO line Items which have Ex-Factory date with in the next 90 days should be included in the file.
The PO line which is deleted should be included in file with all the details of the PO with a deleted indicator.
|
POFEED003
|
Validate filed "street 4"
|
Validate that street 4 is in the last column of the file
|
Solution Details
[Provide complete technical details for configuration or programming here]
Logic for the adding street 4 field in program
1. Fetched address number of the corresponding sold to party from the KNA1 table.
2. Passed address number in ADRC table and taken the street 4 field value.
3. Included street4 field in the last column of the output.
Logic for the including all fields in the output if the shipping instruction changes and also if deletion indicator is checked
1. Added all the required fields in the output by assigning values, if the values are not exits, it will come blank.
Issues
[List Issues / Bugs identified in configuration or development]